package cn.wolfcode.crm.mapper;

import org.apache.ibatis.annotations.Param;
import cn.wolfcode.crm.domain.ProductStock;


public interface ProductStockMapper extends BaseMapper<ProductStock>{
	/**
	 * 通过商品id和仓库id查找商品(join product)
	 * */
	ProductStock selectByDepotIdAndProductId(
			@Param("depotId")Long dId,@Param("productId")Long pId);

    /**
     * 通过商品id和仓库id查找商品(单表查询)
     */
    ProductStock selectByProductAndStockId(@Param("productId") Long id, 
    		@Param("depotId") Long id1);
}
